mysqldump and stored procedures

Posted by Prem on January 4th, 2010 filed in mysql

Today I found out something interesting.  Well, probably its only for me.  Mysqldump does not dump the stored procedures by default.   Default option for mysql dump is to exclude stored procedures.  Where as triggers are include by default.

So, in order to include stored procedures, you have to use option –routines. So, the command goes like:

mysqldump [other options of mysql dump] –routines > out_filename


Leave a Comment

You must be logged in to post a comment.